SUM3D

Adds all the numbers in a range of cells in the whole workbook.

For example, you can use SUM3D to return the sum of the numbers in a given range in the whole workbook. You just need to specify a range, and SUM3D will go through the same range in all worksheets in the workbook and find out the answer for you.

SUM3D is very similar to the SUM function of Microsoft Excel. The main difference is that SUM3D considers all worksheets, while the original SUM function doesn't.

Syntax

SUM(range_input, include_current)

range_input - is the range for which you want to determine the total value or sum.

include_current - Optional. Boolean argument , either TRUE or FALSE. Decides whether the current worksheet is included in the function's consideration. TRUE means the current worksheet will be considered, and vice versa.

Range(s) that include error values or text that cannot be translated into numbers cause errors.

[ ©2000-2001, Edwin H. B. Tam, All rights reserved ]